# -*- coding: utf-8 -*-
from __future__ import unicode_literals
from django.db import models
#
# Create your models here.



class Hospital(models.Model):
    HcoId = models.IntegerField(primary_key=True)
    HcoName = models.CharField("HcoName", max_length=100)
    HcoLevel = models.CharField("HcoLevel", max_length=50)
    HcoAdministrativeLevel = models.CharField("HcoAdministrativeLevel", max_length=50)


class Doctor(models.Model):

    DocId = models.IntegerField(primary_key=True)
    DocName = models.CharField(" DocName",max_length=50)
    Professional_Title = models.CharField("Professional_title",max_length=50)
    Skilled = models.CharField("Skilled",max_length=500)
    Department = models.CharField("Department",max_length=50)
    Age = models.CharField("Age",max_length=5)
    Sex = models.CharField("Sex",max_length=5)
    Hospital = models.ForeignKey(Hospital, related_name="firstcourse")
